www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/qlxr.cpp
// qlxr.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "qlxr.h" #include "ado.h" #include "xlxr.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // qlxr dialog qlxr::qlxr(CWnd* pParent /*=NULL*/) : CDialog(qlxr::IDD, pParent) { //{{AFX_DATA_INIT(qlxr) //}}AFX_DATA_INIT } void qlxr::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(qlxr) DDX_Control(pDX, IDC_EDIT1, m_edit); DDX_Control(pDX, IDC_LIST1, m_list); DDX_Control(pDX, IDC_COMBO2, m_com2); DDX_Control(pDX, IDC_COMBO1, m_com1); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(qlxr, CDialog) //{{AFX_MSG_MAP(qlxr) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1) ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // qlxr message handlers BOOL qlxr::OnInitDialog() { CDialog::OnInitDialog(); this->m_com1.AddString("联系人编号"); this->m_com1.AddString("企业名称"); this->m_com1.AddString("联系人姓名"); this->m_com1.AddString("联系人性别"); this->m_com1.AddString("年龄"); this->m_com1.AddString("职位"); this->m_com1.AddString("办公电话"); this->m_com1.AddString("电子邮件"); this->m_com1.AddString("手机"); this->m_com2.AddString("like"); this->m_com2.AddString("="); // this->m_com2.AddString(">"); // this->m_com2.AddString("<"); // this->m_com2.AddString("<>"); // this->m_com2.AddString(">="); // this->m_com2.AddString("<="); m_list.SetExtendedStyle(LVS_EX_GRIDLINES| LVS_EX_FULLROWSELECT| LVS_EX_HEADERDRAGDROP| LVS_EX_ONECLICKACTIVATE); m_list.InsertColumn(0,"联系人编号"); m_list.InsertColumn(1,"企业名称"); m_list.InsertColumn(2,"联系人姓名"); m_list.InsertColumn(3,"联系人性别"); m_list.InsertColumn(4,"年龄"); m_list.InsertColumn(5,"职位"); m_list.InsertColumn(6,"办公电话"); m_list.InsertColumn(7,"电子邮件"); m_list.InsertColumn(8,"手机"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); m_list.SetColumnWidth(6,100); m_list.SetColumnWidth(7,100); m_list.SetColumnWidth(8,100); this->loadlist(); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void qlxr::OnButton2() { this->EndDialog(true); } void qlxr::OnButton1() { m_list.DeleteAllItems(); ado rst; CString sql,edit1,com1,com2; this->m_edit.GetWindowText(edit1); this->m_com2.GetWindowText(com2); this->m_com1.GetWindowText(com1); if(edit1.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com1.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com2.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com2 == "=") sql.Format("select * from tb_Client_lxrxx where %s %s '%s'",ssel,com2,edit1); else sql.Format("select * from tb_Client_lxrxx where %s %s '%s%s%s'",ssel,com2,"%",edit1,"%"); rst.Open(sql,adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj")); rst.Move(ii); } rst.close(); } void qlxr::loadlist() { ado rst; rst.Open("select * from tb_Client_lxrxx",adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj")); rst.Move(ii); } rst.close(); } void qlxr::OnSelchangeCombo1() { switch(m_com1.GetCurSel()) { case 0: ssel="lxrxx_id"; break; case 1: ssel="lxrxx_qymc"; break; case 2: ssel="lxrxx_xm"; break; case 3: ssel="lxrxx_xb"; break; case 4: ssel="lxrxx_nl"; break; case 5: ssel="lxrxx_zw"; break; case 6: ssel="lxrxx_bgdh"; break; case 7: ssel="lxrxx_Email"; break; case 8: ssel="lxrxx_sj"; break; } } void qlxr::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) { int i=m_list.GetHotItem(); if(i<0) {return;} xlxr l; ado rst; CString ss; ss.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",m_list.GetItemText(i,0)); rst.rstOpen(ss); l.edit1=rst.GetFieldValue("lxrxx_id"); l.com1=rst.GetFieldValue("lxrxx_qymc"); l.edit2=rst.GetFieldValue("lxrxx_xm"); l.com2=rst.GetFieldValue("lxrxx_xb"); l.edit3=rst.GetFieldValue("lxrxx_nl"); l.com3=rst.GetFieldValue("lxrxx_zw"); l.edit4=rst.GetFieldValue("lxrxx_bgdh"); l.edit5=rst.GetFieldValue("lxrxx_Email"); l.edit6=rst.GetFieldValue("lxrxx_sj"); l.date1=rst.GetFieldValue("lxrxx_csny"); l.edit7=rst.GetFieldValue("lxrxx_grjj"); l.date2=rst.GetFieldValue("lxrxx_djrq"); l.edit8=rst.GetFieldValue("lxrxx_xxdjr"); l.edit9=rst.GetFieldValue("lxrxx_bz"); rst.close(); l.DoModal(); *pResult = 0; }